package com.kehutong.charge.dao;

import com.kehutong.charge.entity.ReceiptsStatistics;
import org.coraframework.orm.annotation.Dao;
import org.coraframework.orm.annotation.Mapper;
import org.coraframework.orm.jdbc.execute.Condition;

import java.util.HashMap;
import java.util.List;

@Dao
public interface PayManagesDao {


	@Mapper(
			genericType = ReceiptsStatistics.class,
			sql= "select communityNo communityName,now() statistTime,0 totalNum,0 lastMonthNum,DATE_FORMAT(createTime,'%Y-%m') monthTime,COUNT(id) monthlyNum FROM t_charge_receipt_bill_record WHERE ${}"
	)
	List<ReceiptsStatistics> statistic(Condition... condition);
}
